package com.samsung.booksmanagement;

public class Tbl_Database {

	public static class Tbl_Book {

		public static String TBL_NAME = "tbl_book";

		public static String ID = "_id";
		public static String NAME = "name";
		public static String AUTHOR = "author";
		public static String PUBLISHER = "publisher";
		public static String PUBLISH_DATE = "publishDate";
		public static String IMAGE = "image";

		public static String CREATE_TBALE = "CREATE TABLE " + TBL_NAME + " ( "
				+ ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + AUTHOR
				+ " VARCHAR(64)," + NAME + " VARCHAR(64)," + PUBLISHER
				+ " VARCHAR(64)," + PUBLISH_DATE + " VARCHAR(64)," + IMAGE
				+ " VARCHAR(64)" + " )";
	}

	public static class Tbl_Schedule {

		public static String TBL_NAME = "tbl_schedule";

		public static String ID = "_id";
		public static String ID_BOOK = "book_id";
		public static String TIME = "author";
		public static String SCHEDULE = "publisher";

		public static String CREATE_TBALE = "CREATE TABLE " + TBL_NAME + " (  "
				+ ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + TIME
				+ " VARCHAR(64),"+" book_id INTEGER, " + SCHEDULE + " INTEGER, " + " FOREIGN KEY(book_id) REFERENCES tbl_book(_id)"+" ) ";
	}
}
